﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DsCongCuDatHang" targetNamespace="http://tempuri.org/DsCongCuDatHang.xsd" xmlns:mstns="http://tempuri.org/DsCongCuDatHang.xsd" xmlns="http://tempuri.org/DsCongCuDatHang.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="2" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="techsimex2011_02_10ConnectionString" IsAppSettingsProperty="true" Modifier="Assembly" Name="techsimex2011_02_10ConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.MuaHang.Properties.Settings.GlobalReference.Default.techsimex2011_02_10ConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="E_Smarket_INTERNET" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="E_Smarket_INTERNET (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.MuaHang.Properties.Settings.GlobalReference.Default.E_Smarket_INTERNET" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="HuyHoangSGConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="HuyHoangSGConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.MuaHang.Properties.Settings.GlobalReference.Default.HuyHoangSGConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="VatTuHangHoaTableAdapter" GeneratorDataComponentClassName="VatTuHangHoaTableAdapter" Name="VatTuHangHoa" UserDataComponentName="VatTuHangHoaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HuyHoangSGConnectionString (Settings)" DbObjectName="HuyHoangSG.dbo.VatTuHangHoa" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [VatTuHangHoa] WHERE (([ID] = @Original_ID) AND ([Ma] = @Original_Ma) AND ((@IsNull_Ten = 1 AND [Ten] IS NULL) OR ([Ten] = @Original_Ten)) AND ((@IsNull_DonViTinh = 1 AND [DonViTinh] IS NULL) OR ([DonViTinh] = @Original_DonViTinh)) AND ((@IsNull_NhomVatTuHangHoaID = 1 AND [NhomVatTuHangHoaID] IS NULL) OR ([NhomVatTuHangHoaID] = @Original_NhomVatTuHangHoaID)) AND ((@IsNull_GiaMuaHienTai = 1 AND [GiaMuaHienTai] IS NULL) OR ([GiaMuaHienTai] = @Original_GiaMuaHienTai)) AND ((@IsNull_GiaBanHienTai = 1 AND [GiaBanHienTai] IS NULL) OR ([GiaBanHienTai] = @Original_GiaBanHienTai)) AND ((@IsNull_GiaBia = 1 AND [GiaBia] IS NULL) OR ([GiaBia] = @Original_GiaBia)) AND ((@IsNull_KhoMacDinhID = 1 AND [KhoMacDinhID] IS NULL) OR ([KhoMacDinhID] = @Original_KhoMacDinhID)) AND ((@IsNull_TacGia = 1 AND [TacGia] IS NULL) OR ([TacGia] = @Original_TacGia)) AND ((@IsNull_NhaXuatBan = 1 AND [NhaXuatBan] IS NULL) OR ([NhaXuatBan] = @Original_NhaXuatBan)) AND ([TrangThai] = @Original_TrangThai) AND ((@IsNull_GiaXuatKhoTamTinh = 1 AND [GiaXuatKhoTamTinh] IS NULL) OR ([GiaXuatKhoTamTinh] = @Original_GiaXuatKhoTamTinh)) AND ((@IsNull_LastUpdated = 1 AND [LastUpdated] IS NULL) OR ([LastUpdated] = @Original_LastUpdated)) AND ((@IsNull_NguonCungCap = 1 AND [NguonCungCap] IS NULL) OR ([NguonCungCap] = @Original_NguonCungCap)) AND ((@IsNull_GhiChu = 1 AND [GhiChu] IS NULL) OR ([GhiChu] = @Original_GhiChu)) AND ((@IsNull_ChietKhauBanLe = 1 AND [ChietKhauBanLe] IS NULL) OR ([ChietKhauBanLe] = @Original_ChietKhauBanLe)) AND ((@IsNull_ChietKhauMua = 1 AND [ChietKhauMua] IS NULL) OR ([ChietKhauMua] = @Original_ChietKhauMua)) AND ((@IsNull_ChietKhauBan = 1 AND [ChietKhauBan] IS NULL) OR ([ChietKhauBan] = @Original_ChietKhauBan)) AND ((@IsNull_KichThuoc = 1 AND [KichThuoc] IS NULL) OR ([KichThuoc] = @Original_KichThuoc)) AND ((@IsNull_SoTrang = 1 AND [SoTrang] IS NULL) OR ([SoTrang] = @Original_SoTrang)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DonViTinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DonViTinh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DonViTinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DonViTinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NhomVatTuHangHoaID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NhomVatTuHangHoaID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_NhomVatTuHangHoaID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="NhomVatTuHangHoaID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GiaMuaHienTai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GiaMuaHienTai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_GiaMuaHienTai" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaMuaHienTai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GiaBanHienTai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GiaBanHienTai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_GiaBanHienTai" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaBanHienTai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GiaBia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GiaBia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_GiaBia" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaBia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_KhoMacDinhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KhoMacDinhID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_KhoMacDinhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KhoMacDinhID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TacGia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TacGia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TacGia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TacGia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NhaXuatBan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NhaXuatBan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NhaXuatBan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NhaXuatBan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_TrangThai" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="TrangThai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GiaXuatKhoTamTinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GiaXuatKhoTamTinh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_GiaXuatKhoTamTinh" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaXuatKhoTamTinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastUpdated" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastUpdated" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_LastUpdated" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastUpdated" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NguonCungCap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NguonCungCap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NguonCungCap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NguonCungCap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GhiChu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_GhiChu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ChietKhauBanLe" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauBanLe" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ChietKhauBanLe" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauBanLe" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ChietKhauMua" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauMua" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ChietKhauMua" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauMua" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ChietKhauBan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauBan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ChietKhauBan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauBan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_KichThuoc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KichThuoc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_KichThuoc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KichThuoc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SoTrang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SoTrang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SoTrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SoTrang" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [VatTuHangHoa] ([ID], [Ma], [Ten], [DonViTinh], [NhomVatTuHangHoaID], [GiaMuaHienTai], [GiaBanHienTai], [GiaBia], [KhoMacDinhID], [TacGia], [NhaXuatBan], [TrangThai], [GiaXuatKhoTamTinh], [LastUpdated], [NguonCungCap], [GhiChu], [ChietKhauBanLe], [ChietKhauMua], [ChietKhauBan], [KichThuoc], [SoTrang]) VALUES (@ID, @Ma, @Ten, @DonViTinh, @NhomVatTuHangHoaID, @GiaMuaHienTai, @GiaBanHienTai, @GiaBia, @KhoMacDinhID, @TacGia, @NhaXuatBan, @TrangThai, @GiaXuatKhoTamTinh, @LastUpdated, @NguonCungCap, @GhiChu, @ChietKhauBanLe, @ChietKhauMua, @ChietKhauBan, @KichThuoc, @SoTrang);
SELECT ID, Ma, Ten, DonViTinh, NhomVatTuHangHoaID, GiaMuaHienTai, GiaBanHienTai, GiaBia, KhoMacDinhID, TacGia, NhaXuatBan, TrangThai, GiaXuatKhoTamTinh, LastUpdated, NguonCungCap, GhiChu, ChietKhauBanLe, ChietKhauMua, ChietKhauBan, KichThuoc, SoTrang FROM VatTuHangHoa WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DonViTinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DonViTinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@NhomVatTuHangHoaID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="NhomVatTuHangHoaID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@GiaMuaHienTai" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaMuaHienTai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@GiaBanHienTai" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaBanHienTai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@GiaBia" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaBia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@KhoMacDinhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KhoMacDinhID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TacGia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TacGia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NhaXuatBan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NhaXuatBan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@TrangThai" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="TrangThai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@GiaXuatKhoTamTinh" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaXuatKhoTamTinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@LastUpdated" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastUpdated" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NguonCungCap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NguonCungCap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GhiChu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ChietKhauBanLe" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauBanLe" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ChietKhauMua" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauMua" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ChietKhauBan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauBan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@KichThuoc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KichThuoc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SoTrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SoTrang" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT * FROM VatTuHangHoa</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [VatTuHangHoa] SET [ID] = @ID, [Ma] = @Ma, [Ten] = @Ten, [DonViTinh] = @DonViTinh, [NhomVatTuHangHoaID] = @NhomVatTuHangHoaID, [GiaMuaHienTai] = @GiaMuaHienTai, [GiaBanHienTai] = @GiaBanHienTai, [GiaBia] = @GiaBia, [KhoMacDinhID] = @KhoMacDinhID, [TacGia] = @TacGia, [NhaXuatBan] = @NhaXuatBan, [TrangThai] = @TrangThai, [GiaXuatKhoTamTinh] = @GiaXuatKhoTamTinh, [LastUpdated] = @LastUpdated, [NguonCungCap] = @NguonCungCap, [GhiChu] = @GhiChu, [ChietKhauBanLe] = @ChietKhauBanLe, [ChietKhauMua] = @ChietKhauMua, [ChietKhauBan] = @ChietKhauBan, [KichThuoc] = @KichThuoc, [SoTrang] = @SoTrang WHERE (([ID] = @Original_ID) AND ([Ma] = @Original_Ma) AND ((@IsNull_Ten = 1 AND [Ten] IS NULL) OR ([Ten] = @Original_Ten)) AND ((@IsNull_DonViTinh = 1 AND [DonViTinh] IS NULL) OR ([DonViTinh] = @Original_DonViTinh)) AND ((@IsNull_NhomVatTuHangHoaID = 1 AND [NhomVatTuHangHoaID] IS NULL) OR ([NhomVatTuHangHoaID] = @Original_NhomVatTuHangHoaID)) AND ((@IsNull_GiaMuaHienTai = 1 AND [GiaMuaHienTai] IS NULL) OR ([GiaMuaHienTai] = @Original_GiaMuaHienTai)) AND ((@IsNull_GiaBanHienTai = 1 AND [GiaBanHienTai] IS NULL) OR ([GiaBanHienTai] = @Original_GiaBanHienTai)) AND ((@IsNull_GiaBia = 1 AND [GiaBia] IS NULL) OR ([GiaBia] = @Original_GiaBia)) AND ((@IsNull_KhoMacDinhID = 1 AND [KhoMacDinhID] IS NULL) OR ([KhoMacDinhID] = @Original_KhoMacDinhID)) AND ((@IsNull_TacGia = 1 AND [TacGia] IS NULL) OR ([TacGia] = @Original_TacGia)) AND ((@IsNull_NhaXuatBan = 1 AND [NhaXuatBan] IS NULL) OR ([NhaXuatBan] = @Original_NhaXuatBan)) AND ([TrangThai] = @Original_TrangThai) AND ((@IsNull_GiaXuatKhoTamTinh = 1 AND [GiaXuatKhoTamTinh] IS NULL) OR ([GiaXuatKhoTamTinh] = @Original_GiaXuatKhoTamTinh)) AND ((@IsNull_LastUpdated = 1 AND [LastUpdated] IS NULL) OR ([LastUpdated] = @Original_LastUpdated)) AND ((@IsNull_NguonCungCap = 1 AND [NguonCungCap] IS NULL) OR ([NguonCungCap] = @Original_NguonCungCap)) AND ((@IsNull_GhiChu = 1 AND [GhiChu] IS NULL) OR ([GhiChu] = @Original_GhiChu)) AND ((@IsNull_ChietKhauBanLe = 1 AND [ChietKhauBanLe] IS NULL) OR ([ChietKhauBanLe] = @Original_ChietKhauBanLe)) AND ((@IsNull_ChietKhauMua = 1 AND [ChietKhauMua] IS NULL) OR ([ChietKhauMua] = @Original_ChietKhauMua)) AND ((@IsNull_ChietKhauBan = 1 AND [ChietKhauBan] IS NULL) OR ([ChietKhauBan] = @Original_ChietKhauBan)) AND ((@IsNull_KichThuoc = 1 AND [KichThuoc] IS NULL) OR ([KichThuoc] = @Original_KichThuoc)) AND ((@IsNull_SoTrang = 1 AND [SoTrang] IS NULL) OR ([SoTrang] = @Original_SoTrang)));
SELECT ID, Ma, Ten, DonViTinh, NhomVatTuHangHoaID, GiaMuaHienTai, GiaBanHienTai, GiaBia, KhoMacDinhID, TacGia, NhaXuatBan, TrangThai, GiaXuatKhoTamTinh, LastUpdated, NguonCungCap, GhiChu, ChietKhauBanLe, ChietKhauMua, ChietKhauBan, KichThuoc, SoTrang FROM VatTuHangHoa WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DonViTinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DonViTinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@NhomVatTuHangHoaID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="NhomVatTuHangHoaID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@GiaMuaHienTai" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaMuaHienTai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@GiaBanHienTai" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaBanHienTai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@GiaBia" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaBia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@KhoMacDinhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KhoMacDinhID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TacGia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TacGia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NhaXuatBan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NhaXuatBan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@TrangThai" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="TrangThai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@GiaXuatKhoTamTinh" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaXuatKhoTamTinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@LastUpdated" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastUpdated" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NguonCungCap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NguonCungCap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GhiChu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ChietKhauBanLe" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauBanLe" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ChietKhauMua" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauMua" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ChietKhauBan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauBan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@KichThuoc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KichThuoc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SoTrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SoTrang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DonViTinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DonViTinh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DonViTinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DonViTinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NhomVatTuHangHoaID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NhomVatTuHangHoaID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_NhomVatTuHangHoaID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="NhomVatTuHangHoaID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GiaMuaHienTai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GiaMuaHienTai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_GiaMuaHienTai" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaMuaHienTai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GiaBanHienTai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GiaBanHienTai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_GiaBanHienTai" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaBanHienTai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GiaBia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GiaBia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_GiaBia" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaBia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_KhoMacDinhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KhoMacDinhID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_KhoMacDinhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KhoMacDinhID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TacGia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TacGia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TacGia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TacGia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NhaXuatBan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NhaXuatBan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NhaXuatBan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NhaXuatBan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_TrangThai" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="TrangThai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GiaXuatKhoTamTinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GiaXuatKhoTamTinh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_GiaXuatKhoTamTinh" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaXuatKhoTamTinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastUpdated" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastUpdated" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_LastUpdated" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastUpdated" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NguonCungCap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NguonCungCap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NguonCungCap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NguonCungCap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GhiChu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_GhiChu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ChietKhauBanLe" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauBanLe" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ChietKhauBanLe" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauBanLe" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ChietKhauMua" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauMua" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ChietKhauMua" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauMua" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ChietKhauBan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauBan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ChietKhauBan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauBan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_KichThuoc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KichThuoc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_KichThuoc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KichThuoc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SoTrang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SoTrang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SoTrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SoTrang" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Ma" DataSetColumn="Ma" />
              <Mapping SourceColumn="Ten" DataSetColumn="Ten" />
              <Mapping SourceColumn="DonViTinh" DataSetColumn="DonViTinh" />
              <Mapping SourceColumn="NhomVatTuHangHoaID" DataSetColumn="NhomVatTuHangHoaID" />
              <Mapping SourceColumn="GiaMuaHienTai" DataSetColumn="GiaMuaHienTai" />
              <Mapping SourceColumn="GiaBanHienTai" DataSetColumn="GiaBanHienTai" />
              <Mapping SourceColumn="GiaBia" DataSetColumn="GiaBia" />
              <Mapping SourceColumn="KhoMacDinhID" DataSetColumn="KhoMacDinhID" />
              <Mapping SourceColumn="TacGia" DataSetColumn="TacGia" />
              <Mapping SourceColumn="NhaXuatBan" DataSetColumn="NhaXuatBan" />
              <Mapping SourceColumn="TrangThai" DataSetColumn="TrangThai" />
              <Mapping SourceColumn="GiaXuatKhoTamTinh" DataSetColumn="GiaXuatKhoTamTinh" />
              <Mapping SourceColumn="LastUpdated" DataSetColumn="LastUpdated" />
              <Mapping SourceColumn="NguonCungCap" DataSetColumn="NguonCungCap" />
              <Mapping SourceColumn="GhiChu" DataSetColumn="GhiChu" />
              <Mapping SourceColumn="ChietKhauBanLe" DataSetColumn="ChietKhauBanLe" />
              <Mapping SourceColumn="ChietKhauMua" DataSetColumn="ChietKhauMua" />
              <Mapping SourceColumn="ChietKhauBan" DataSetColumn="ChietKhauBan" />
              <Mapping SourceColumn="KichThuoc" DataSetColumn="KichThuoc" />
              <Mapping SourceColumn="SoTrang" DataSetColumn="SoTrang" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DsCongCuDatHang" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DsCongCuDatHang" msprop:Generator_DataSetName="DsCongCuDatHang" msprop:EnableTableAdapterManager="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Detail" msprop:Generator_UserTableName="Detail" msprop:Generator_RowDeletedName="DetailRowDeleted" msprop:Generator_RowChangedName="DetailRowChanged" msprop:Generator_RowClassName="DetailRow" msprop:Generator_RowChangingName="DetailRowChanging" msprop:Generator_RowEvArgName="DetailRowChangeEvent" msprop:Generator_RowEvHandlerName="DetailRowChangeEventHandler" msprop:Generator_TableClassName="DetailDataTable" msprop:Generator_TableVarName="tableDetail" msprop:Generator_RowDeletingName="DetailRowDeleting" msprop:Generator_TablePropName="Detail">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Ma" msprop:Generator_UserColumnName="Ma" msprop:Generator_ColumnVarNameInTable="columnMa" msprop:Generator_ColumnPropNameInRow="Ma" msprop:Generator_ColumnPropNameInTable="MaColumn" type="xs:string" minOccurs="0" />
              <xs:element name="Ten" msprop:Generator_UserColumnName="Ten" msprop:Generator_ColumnVarNameInTable="columnTen" msprop:Generator_ColumnPropNameInRow="Ten" msprop:Generator_ColumnPropNameInTable="TenColumn" type="xs:string" minOccurs="0" />
              <xs:element name="GiaBia" msprop:Generator_UserColumnName="GiaBia" msprop:Generator_ColumnVarNameInTable="columnGiaBia" msprop:Generator_ColumnPropNameInRow="GiaBia" msprop:Generator_ColumnPropNameInTable="GiaBiaColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="TenNhomVatTuHangHoa" msprop:Generator_UserColumnName="TenNhomVatTuHangHoa" msprop:Generator_ColumnVarNameInTable="columnTenNhomVatTuHangHoa" msprop:Generator_ColumnPropNameInRow="TenNhomVatTuHangHoa" msprop:Generator_ColumnPropNameInTable="TenNhomVatTuHangHoaColumn" type="xs:string" minOccurs="0" />
              <xs:element name="SoLuongTonDauKy" msprop:Generator_UserColumnName="SoLuongTonDauKy" msprop:Generator_ColumnPropNameInRow="SoLuongTonDauKy" msprop:Generator_ColumnVarNameInTable="columnSoLuongTonDauKy" msprop:Generator_ColumnPropNameInTable="SoLuongTonDauKyColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="SoLuongNhap" msprop:Generator_UserColumnName="SoLuongNhap" msprop:Generator_ColumnVarNameInTable="columnSoLuongNhap" msprop:Generator_ColumnPropNameInRow="SoLuongNhap" msprop:Generator_ColumnPropNameInTable="SoLuongNhapColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="SoLuongXuat" msprop:Generator_UserColumnName="SoLuongXuat" msprop:Generator_ColumnVarNameInTable="columnSoLuongXuat" msprop:Generator_ColumnPropNameInRow="SoLuongXuat" msprop:Generator_ColumnPropNameInTable="SoLuongXuatColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="TongTonTheoNhaCungCap" msprop:Generator_UserColumnName="TongTonTheoNhaCungCap" msprop:Generator_ColumnPropNameInRow="TongTonTheoNhaCungCap" msprop:Generator_ColumnVarNameInTable="columnTongTonTheoNhaCungCap" msprop:Generator_ColumnPropNameInTable="TongTonTheoNhaCungCapColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="SoLuongTon" msprop:Generator_UserColumnName="SoLuongTon" msprop:Generator_ColumnVarNameInTable="columnSoLuongTon" msprop:Generator_ColumnPropNameInRow="SoLuongTon" msprop:Generator_ColumnPropNameInTable="SoLuongTonColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="SoLuongTraLai" msprop:Generator_UserColumnName="SoLuongTraLai" msprop:Generator_ColumnVarNameInTable="columnSoLuongTraLai" msprop:Generator_ColumnPropNameInRow="SoLuongTraLai" msprop:Generator_ColumnPropNameInTable="SoLuongTraLaiColumn" type="xs:string" minOccurs="0" />
              <xs:element name="SoLuongDat" msprop:Generator_UserColumnName="SoLuongDat" msprop:Generator_ColumnVarNameInTable="columnSoLuongDat" msprop:Generator_ColumnPropNameInRow="SoLuongDat" msprop:Generator_ColumnPropNameInTable="SoLuongDatColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="SoLuongTra" msprop:Generator_UserColumnName="SoLuongTra" msprop:Generator_ColumnVarNameInTable="columnSoLuongTra" msprop:Generator_ColumnPropNameInRow="SoLuongTra" msprop:Generator_ColumnPropNameInTable="SoLuongTraColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="TacGia" msprop:Generator_UserColumnName="TacGia" msprop:Generator_ColumnPropNameInRow="TacGia" msprop:Generator_ColumnVarNameInTable="columnTacGia" msprop:Generator_ColumnPropNameInTable="TacGiaColumn" type="xs:string" minOccurs="0" />
              <xs:element name="NhaXuatBan" msprop:Generator_UserColumnName="NhaXuatBan" msprop:Generator_ColumnPropNameInRow="NhaXuatBan" msprop:Generator_ColumnVarNameInTable="columnNhaXuatBan" msprop:Generator_ColumnPropNameInTable="NhaXuatBanColumn" type="xs:string" minOccurs="0" />
              <xs:element name="NguonCungCap" msprop:Generator_UserColumnName="NguonCungCap" msprop:Generator_ColumnPropNameInRow="NguonCungCap" msprop:Generator_ColumnVarNameInTable="columnNguonCungCap" msprop:Generator_ColumnPropNameInTable="NguonCungCapColumn" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="VatTuHangHoa" msprop:Generator_UserTableName="VatTuHangHoa" msprop:Generator_RowDeletedName="VatTuHangHoaRowDeleted" msprop:Generator_RowChangedName="VatTuHangHoaRowChanged" msprop:Generator_RowClassName="VatTuHangHoaRow" msprop:Generator_RowChangingName="VatTuHangHoaRowChanging" msprop:Generator_RowEvArgName="VatTuHangHoaRowChangeEvent" msprop:Generator_RowEvHandlerName="VatTuHangHoaRowChangeEventHandler" msprop:Generator_TableClassName="VatTuHangHoaDataTable" msprop:Generator_TableVarName="tableVatTuHangHoa" msprop:Generator_RowDeletingName="VatTuHangHoaRowDeleting" msprop:Generator_TablePropName="VatTuHangHoa">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Choose" msprop:Generator_UserColumnName="Choose" msprop:Generator_ColumnVarNameInTable="columnChoose" msprop:Generator_ColumnPropNameInRow="Choose" msprop:Generator_ColumnPropNameInTable="ChooseColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="ID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:string" />
              <xs:element name="Ma" msprop:Generator_UserColumnName="Ma" msprop:Generator_ColumnVarNameInTable="columnMa" msprop:Generator_ColumnPropNameInRow="Ma" msprop:Generator_ColumnPropNameInTable="MaColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ten" msprop:Generator_UserColumnName="Ten" msprop:Generator_ColumnVarNameInTable="columnTen" msprop:Generator_ColumnPropNameInRow="Ten" msprop:Generator_ColumnPropNameInTable="TenColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="300" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DonViTinh" msprop:Generator_UserColumnName="DonViTinh" msprop:Generator_ColumnVarNameInTable="columnDonViTinh" msprop:Generator_ColumnPropNameInRow="DonViTinh" msprop:Generator_ColumnPropNameInTable="DonViTinhColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NhomVatTuHangHoaID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="NhomVatTuHangHoaID" msprop:Generator_ColumnVarNameInTable="columnNhomVatTuHangHoaID" msprop:Generator_ColumnPropNameInRow="NhomVatTuHangHoaID" msprop:Generator_ColumnPropNameInTable="NhomVatTuHangHoaIDColumn" type="xs:string" minOccurs="0" />
              <xs:element name="GiaMuaHienTai" msprop:Generator_UserColumnName="GiaMuaHienTai" msprop:Generator_ColumnVarNameInTable="columnGiaMuaHienTai" msprop:Generator_ColumnPropNameInRow="GiaMuaHienTai" msprop:Generator_ColumnPropNameInTable="GiaMuaHienTaiColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="GiaBanHienTai" msprop:Generator_UserColumnName="GiaBanHienTai" msprop:Generator_ColumnVarNameInTable="columnGiaBanHienTai" msprop:Generator_ColumnPropNameInRow="GiaBanHienTai" msprop:Generator_ColumnPropNameInTable="GiaBanHienTaiColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="GiaBia" msprop:Generator_UserColumnName="GiaBia" msprop:Generator_ColumnVarNameInTable="columnGiaBia" msprop:Generator_ColumnPropNameInRow="GiaBia" msprop:Generator_ColumnPropNameInTable="GiaBiaColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="KhoMacDinhID" msprop:Generator_UserColumnName="KhoMacDinhID" msprop:Generator_ColumnVarNameInTable="columnKhoMacDinhID" msprop:Generator_ColumnPropNameInRow="KhoMacDinhID" msprop:Generator_ColumnPropNameInTable="KhoMacDinhIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TacGia" msprop:Generator_UserColumnName="TacGia" msprop:Generator_ColumnVarNameInTable="columnTacGia" msprop:Generator_ColumnPropNameInRow="TacGia" msprop:Generator_ColumnPropNameInTable="TacGiaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="300" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NhaXuatBan" msprop:Generator_UserColumnName="NhaXuatBan" msprop:Generator_ColumnVarNameInTable="columnNhaXuatBan" msprop:Generator_ColumnPropNameInRow="NhaXuatBan" msprop:Generator_ColumnPropNameInTable="NhaXuatBanColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="300" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TrangThai" msprop:Generator_UserColumnName="TrangThai" msprop:Generator_ColumnVarNameInTable="columnTrangThai" msprop:Generator_ColumnPropNameInRow="TrangThai" msprop:Generator_ColumnPropNameInTable="TrangThaiColumn" type="xs:boolean" />
              <xs:element name="GiaXuatKhoTamTinh" msprop:Generator_UserColumnName="GiaXuatKhoTamTinh" msprop:Generator_ColumnVarNameInTable="columnGiaXuatKhoTamTinh" msprop:Generator_ColumnPropNameInRow="GiaXuatKhoTamTinh" msprop:Generator_ColumnPropNameInTable="GiaXuatKhoTamTinhColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="LastUpdated" msprop:Generator_UserColumnName="LastUpdated" msprop:Generator_ColumnVarNameInTable="columnLastUpdated" msprop:Generator_ColumnPropNameInRow="LastUpdated" msprop:Generator_ColumnPropNameInTable="LastUpdatedColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="NguonCungCap" msprop:Generator_UserColumnName="NguonCungCap" msprop:Generator_ColumnVarNameInTable="columnNguonCungCap" msprop:Generator_ColumnPropNameInRow="NguonCungCap" msprop:Generator_ColumnPropNameInTable="NguonCungCapColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GhiChu" msprop:Generator_UserColumnName="GhiChu" msprop:Generator_ColumnVarNameInTable="columnGhiChu" msprop:Generator_ColumnPropNameInRow="GhiChu" msprop:Generator_ColumnPropNameInTable="GhiChuColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="300" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ChietKhauBanLe" msprop:Generator_UserColumnName="ChietKhauBanLe" msprop:Generator_ColumnVarNameInTable="columnChietKhauBanLe" msprop:Generator_ColumnPropNameInRow="ChietKhauBanLe" msprop:Generator_ColumnPropNameInTable="ChietKhauBanLeColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ChietKhauMua" msprop:Generator_UserColumnName="ChietKhauMua" msprop:Generator_ColumnVarNameInTable="columnChietKhauMua" msprop:Generator_ColumnPropNameInRow="ChietKhauMua" msprop:Generator_ColumnPropNameInTable="ChietKhauMuaColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ChietKhauBan" msprop:Generator_UserColumnName="ChietKhauBan" msprop:Generator_ColumnVarNameInTable="columnChietKhauBan" msprop:Generator_ColumnPropNameInRow="ChietKhauBan" msprop:Generator_ColumnPropNameInTable="ChietKhauBanColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="KichThuoc" msprop:Generator_UserColumnName="KichThuoc" msprop:Generator_ColumnVarNameInTable="columnKichThuoc" msprop:Generator_ColumnPropNameInRow="KichThuoc" msprop:Generator_ColumnPropNameInTable="KichThuocColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SoTrang" msprop:Generator_UserColumnName="SoTrang" msprop:Generator_ColumnVarNameInTable="columnSoTrang" msprop:Generator_ColumnPropNameInRow="SoTrang" msprop:Generator_ColumnPropNameInTable="SoTrangColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:VatTuHangHoa" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
  </xs:element>
</xs:schema>